﻿-- Creating table 'ProductPricingPerUnits'
CREATE TABLE [dbo].[ProductPricingPerUnits] (
    [Id] int IDENTITY(1,1) NOT NULL,
    [Name] nvarchar(50)  NOT NULL,
    [PurchasingPrice] float  NOT NULL,
    [SellingPrice] float  NOT NULL,
    [CreateOn] datetime  NOT NULL,
    [DeleteOn] datetime  NULL
);
GO
-- Creating primary key on [Id] in table 'ProductPricingPerUnits'
ALTER TABLE [dbo].[ProductPricingPerUnits]
ADD CONSTRAINT [PK_ProductPricingPerUnits]
    PRIMARY KEY CLUSTERED ([Id] ASC);